UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cGVNhlsGfo9o4Ok1TD3ZCYDntZcla/eAodHEMeVrIYw='
WHERE
key_id = '59c4683a1bf51bc22abc79e8e766038d493543b0a87b6746020bf5558ba8f78e'
AND (
token = 'cGVNhlsGfo9o4Ok1TD3ZCYDntZcla/eAodHEMeVrIYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)