UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gMz40BIgAJxRhSl+TrgrXaepzOywaGOuTPcdqHBKAAs='
WHERE
key_id = 'd38c7c46b24f21bdc43a5f5146824bbc6684b6eb061709fffd4401f25203907e'
AND (
token = 'gMz40BIgAJxRhSl+TrgrXaepzOywaGOuTPcdqHBKAAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)