UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8sZmHwOYcGXOvgCoWewQ8SM1tcC0Nc8gwoFr3CuRzlI='
WHERE
key_id = 'cfd60662d9f0fa88cbd7a483d9bb1bb52e8d4e9894d06bf9570a1fc36dff6702'
AND (
token = '8sZmHwOYcGXOvgCoWewQ8SM1tcC0Nc8gwoFr3CuRzlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)