UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zj6svvrgS298+ffNTaDwOv+79Xa3hIc6J7xbZ1G3qmo='
WHERE
key_id = 'cf528cd15b7848941aa9997e6ce115f5cf07598485e53443a2127370287fa195'
AND (
token = 'zj6svvrgS298+ffNTaDwOv+79Xa3hIc6J7xbZ1G3qmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)