UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2n30hx1m9NkQdKGzSfgRG8wWV1xNFO6UeLWZwkvrSDM='
WHERE
key_id = '8b171b7a9d5fb45ffa44f064e90e712e7b9139310aba88694fe10e6adc35ed9d'
AND (
token = '2n30hx1m9NkQdKGzSfgRG8wWV1xNFO6UeLWZwkvrSDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)