UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A2Pr274BMAac0JW+GgCdig9uQtTDbrolJiX+0Q+MJbg='
WHERE
key_id = '4a7a1b2350bd82d26c6be64d7452b8f4d9cc30cf888d5a742df037a008f84d3a'
AND (
token = 'A2Pr274BMAac0JW+GgCdig9uQtTDbrolJiX+0Q+MJbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)