UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rDo3d11mxTRYv2QmX60RDsV5gy3eFHg8bMprAgt2C2c='
WHERE
key_id = 'd00b6357b97397198211dd286c36e14cd9f8428631debbfe3c9e34a6b4dabce5'
AND (
token = 'rDo3d11mxTRYv2QmX60RDsV5gy3eFHg8bMprAgt2C2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)