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