UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCfcWJEUbO5o/SrDkfJ/jNNvwiOYuAK+VnGa33EhmHY='
WHERE
key_id = '6a837bda5db3c503ada05baf4b570123ae13407884e9c5b73e91046732df36a3'
AND (
token = 'cCfcWJEUbO5o/SrDkfJ/jNNvwiOYuAK+VnGa33EhmHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)