UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v7DY9B/nTDERLT69k9LSZxPte1cHTLpqBiezrypZzxM='
WHERE
key_id = '48b73e265304609968d5568bd7782e1248f6e8a18eb4a3311b6c0af185c74a08'
AND (
token = 'v7DY9B/nTDERLT69k9LSZxPte1cHTLpqBiezrypZzxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)