UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VfMw3u6KxaWE+hDmY1rBN11PH1xw5xkaYEMc7+t8R84='
WHERE
key_id = 'e9c6a9526fd510b6b35f3f6b20201b94499d21ac12dcfa1caf0ff6b6dcf6cf55'
AND (
token = 'VfMw3u6KxaWE+hDmY1rBN11PH1xw5xkaYEMc7+t8R84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)