UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '22mYgBhC2o5oB58zuk8Rd2mYkEWnJquuZ5tCdfoHCrI='
WHERE
key_id = 'ba9d48ebd1ea86867374487807d4ac93080cd2037839166b30c2b2cf9d23e731'
AND (
token = '22mYgBhC2o5oB58zuk8Rd2mYkEWnJquuZ5tCdfoHCrI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)