UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x2u8Vz7A8LEE8/yL/4KsmOYHK4tZoc6IZUISwH3MROg='
WHERE
key_id = '31ad9e1b2f569f39cd86aa430c1d113d33580eccdb9532833b777454701fb3cb'
AND (
token = 'x2u8Vz7A8LEE8/yL/4KsmOYHK4tZoc6IZUISwH3MROg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)