UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hsNlWVPuuIL0oRBCwLWR8RS4RTAMFpB5ZxZnZHSakkg='
WHERE
key_id = 'ca667e4c104e41209250a56799b0c339b6d54f951b82876d51a8cdf83af52f7f'
AND (
token = 'hsNlWVPuuIL0oRBCwLWR8RS4RTAMFpB5ZxZnZHSakkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)