UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNqcEa7VoBAJwGzkDwgIwrh9XvEsEpfQQi2/7j5qh9Q='
WHERE
key_id = '814a206c0fba79dfe6d0d59c08b8a68e4fe74d927f51ce1f54b86f0192dbe3ab'
AND (
token = 'zNqcEa7VoBAJwGzkDwgIwrh9XvEsEpfQQi2/7j5qh9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)