UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKXsBQUolGH1JOKAd/gegrXlgEHdWKtxxC3xayc7zHY='
WHERE
key_id = 'c25120e67676bcdc701cbc7d8fca28d47be8052cde1294ab5758d714c93b89cc'
AND (
token = 'KKXsBQUolGH1JOKAd/gegrXlgEHdWKtxxC3xayc7zHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)