UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bJXXn0xI8gAlRassplmITIIsIPfnhUh0/XPhAsy9ccE='
WHERE
key_id = '0496c9fbff65c1a6cb23223f3f8b438a4d1fc60b0d7dcb79bebec81f3dcfb5c8'
AND (
token = 'bJXXn0xI8gAlRassplmITIIsIPfnhUh0/XPhAsy9ccE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)