UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7pNlWUNZkyXZG7bZ8eK8GDbOkKlmPAy4dNS8UJDC1xQ='
WHERE
key_id = '191a37ce1b8f4a400ab25dfad1218e431bea04e7d02091c030f04a94ecff2520'
AND (
token = '7pNlWUNZkyXZG7bZ8eK8GDbOkKlmPAy4dNS8UJDC1xQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)