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