UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ztHSy7xkEOQUGul7pepUTdw3LnG0kviFFNHtNyRt24U='
WHERE
key_id = 'b901a999357d7fd1fd3a303c40edba1bad2fe6d07e4bc5f145493bff1d9f74d4'
AND (
token = 'ztHSy7xkEOQUGul7pepUTdw3LnG0kviFFNHtNyRt24U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)