UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vpRCajbr9Y1NTE7TCaVmvx/FHDhgiM89nOCy1USGbGk='
WHERE
key_id = '339b169538a59a048daefe92a8114fb69a748d11b068b116e452a4bd23f95244'
AND (
token = 'vpRCajbr9Y1NTE7TCaVmvx/FHDhgiM89nOCy1USGbGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)