UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sjcFL1/VRdTCHLySok1wWlrVMopS0wFiGhceQ9I8qU0='
WHERE
key_id = '784184a09870d204c8b4d113082841d267bc6580d9ba97e9090836495e3ec3d9'
AND (
token = 'sjcFL1/VRdTCHLySok1wWlrVMopS0wFiGhceQ9I8qU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)