UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fXxCf6OFrVH35rgX+La/KaCQMmKgv3FwkXDUH43WPgo='
WHERE
key_id = 'f84e0d2df6db399ffb8fc43e3294dce187d43ce512f81b957b864be6543e4153'
AND (
token = 'fXxCf6OFrVH35rgX+La/KaCQMmKgv3FwkXDUH43WPgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)