UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm6lIvO/3sa8X8RmJzdiYCc0utRjpCEsJ5O+F8NnkHl0='
WHERE
key_id = '293440e7342be390f28ae85774d086505343f77d88586e912e7a7ea2ef154240'
AND (
token = 'm6lIvO/3sa8X8RmJzdiYCc0utRjpCEsJ5O+F8NnkHl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)