UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X29Fu9wroe9KptOEaH/pQMshSHOjOD4IpUWc82bWNyU='
WHERE
key_id = 'e7e0ac8b78963d51e844dd815e1204e2ff38407b3a6cdeb10175ee842a0d705f'
AND (
token = 'X29Fu9wroe9KptOEaH/pQMshSHOjOD4IpUWc82bWNyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)