UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9iiQ4YjD2oPp4G07bizgeb1H042mjU9O8mmt5MJ8pdg=' 
WHERE 
  key_id = 'e4f9e6e4b7ef621ada8419ddfef68d9ce7ca37be57c30df820aebba024e3769f' 
  AND (
    token = '9iiQ4YjD2oPp4G07bizgeb1H042mjU9O8mmt5MJ8pdg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031