UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cth52LOIEbXNFzikq41cdiz5a8cWxnNWfzHe7jWKOjY='
WHERE
key_id = '514511c5949722953261f8ef4e1011042a337cb2741ea4d2c43bff4db174a05f'
AND (
token = 'cth52LOIEbXNFzikq41cdiz5a8cWxnNWfzHe7jWKOjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)