UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mpXTGNXm8+BWnkIrWXq8gHZpxO+05dWrpa3GUogQrbk='
WHERE
key_id = '65be16247a715b1d88d2aeb7a9fea3b35f92f7e4acec785e4c1a0a0433dfac42'
AND (
token = 'mpXTGNXm8+BWnkIrWXq8gHZpxO+05dWrpa3GUogQrbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)