UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qWnvWrvMwhKIYfRR+LDnF4y391xWZzO/IVgOej2cTs='
WHERE
key_id = 'e56be1b283e56418a6dc35d4cb268f43c48edd5ad5d27751a62367d4765c7b77'
AND (
token = '9qWnvWrvMwhKIYfRR+LDnF4y391xWZzO/IVgOej2cTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)