UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qA9rCaFpc+z7wBgqq+7H0BOVKx1zV3EaEUEEEyl8L+w='
WHERE
key_id = '7e858f9e7464507ba3acc4b56c2a5e940d4515b9288dadf470d7c144f4f67504'
AND (
token = 'qA9rCaFpc+z7wBgqq+7H0BOVKx1zV3EaEUEEEyl8L+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)