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