UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cSaXnhGh2jlpdW9aT+p7RKRMCKt9vcHCqFMUASVnGag='
WHERE
key_id = 'de7183d89f58677592aed1e0f1ee539b2ede5f1ad5dd7ca5bb9ff445375c077d'
AND (
token = 'cSaXnhGh2jlpdW9aT+p7RKRMCKt9vcHCqFMUASVnGag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)