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